USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[ChatLogInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.ChatLogInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	ChatLog Table Insert
-- =============================================
CREATE PROCEDURE ChatLogInsert

		   @ChatLogId int,
           @PlayerId varchar(30),
           @TeamId int,
           @Text text,
           @DateTime datetime,
           @LogId int,
           @RoundId int,
           @MiniRoundId int,
           @ChatType varchar(20)
	

AS
BEGIN

INSERT INTO [ChatLog]
           ([ChatLogId]
		  ,[PlayerId]
		  ,[TeamId]
		  ,[Text]
		  ,[DateTime]
		  ,[LogId]
		  ,[RoundId]
		  ,[MiniRoundId]
		  ,[ChatType])
     VALUES
           (@ChatLogId,
           @PlayerId,
           @TeamId,
           @Text,
           @DateTime,
           @LogId,
           @RoundId,
           @MiniRoundId,
           @ChatType)

END
GO


